package com.lenovo.codestatreport.jira.mapper;

import com.lenovo.codestatreport.jira.model.AssigneeAndReporter;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @author Howie Lu
 * @version Created at 2019/05/20
 * @version Updated at 2019/05/21
 */
@Mapper
public interface AssigneeAndReporterMapper {

    List<AssigneeAndReporter> selectAllByTime(@Param("tablename")String tablename, String start, String end);

    List<AssigneeAndReporter> selectAll(@Param("tablename")String tablename);

    List<AssigneeAndReporter> selectByProjectKey(@Param("tablename")String tablename, String projectkey);

    List<AssigneeAndReporter> selectByProjectKeyByTime(@Param("tablename")String tablename, String projectkey, String start, String end);

    List<String> selectAllProjects(@Param("tablename")String tablename);

    List<AssigneeAndReporter> selectByStaffByTime(@Param("tablename")String tablename, String staffId, String start, String end);

}
